home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
JCSM Shareware Collection 1996 September
/
JCSM Shareware Collection (JCS Distribution) (September 1996).ISO
/
medhelth
/
med107.zip
/
INSTMED6.EXE
/
MED_107.PT8
< prev
Wrap
Text File
|
1993-08-22
|
42KB
|
1,241 lines
---------------------------------------------------------
FILE - HISTORY
---------------------------------------------------------
FIELD TYPE LEN DEC
ACCT C 5 Primary identification code for
billing functions. Each account
can have from 1 to 999 patients.
PATIENT C 2 Code to identify this patient
within an account. You can have
up to 999 patients per account.
You must have at least one
patient per account.
TRN_DATE D 8 Transaction posting date -
mm/dd/yy.
CHG_TABLE C 2 Code to identify this charge
table of rates. You can setup
100 unique charge tables. The
table code of '00' is reserved
for the default 'standard'
charge table. Each table is
unique and is identified to the
patient at time of patient
setup. Table code can be
overriden at time of transaction
posting in order to post charges
to a patient from another table.
CHG_CODE C 8 Primary code used to identify
the charge, adjustment, or type
of payment. This code is
combined with the 'CHG_TABLE'
code in order to fully identify
the transaction.
CHG_DESC C 32 A brief description that will
better describe the transaction.
TRN_DOC C 2 Doctor seeing patient for this
transaction. This is the default
patient doctor but can be
changed at time of transaction
posting.
HIS_COMT1 C 50 Comment entry line #1 for
transaction history record.
Page 146
---------------------------------------------------------
FILE - HISTORY
---------------------------------------------------------
FIELD TYPE LEN DEC
HIS_COMT2 C 50 Comment line #2 for transaction
history record.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 167
Page 147
---------------------------------------------------------
FILE - RECALLS
---------------------------------------------------------
FIELD TYPE LEN DEC
ACCT C 5 Primary identification code for
billing functions. Each account
can have from 1 to 999 patients.
PATIENT C 2 Code to identify this patient
within an account. You can have
up to 999 patients per account.
You must have at least one
patient per account.
CHG_TABLE C 2 Code to identify this charge
table of rates. You can setup
100 unique charge tables. The
table code of '00' is reserved
for the default 'standard'
charge table. Each table is
unique and is identified to the
patient at time of patient
setup. Table code can be
overriden at time of transaction
posting in order to post charges
to a patient from another table.
CHG_CODE C 8 Primary code used to identify
the charge, adjustment, or type
of payment. This code is
combined with the 'CHG_TABLE'
code in order to fully identify
the transaction.
CHG_DESC C 32 A brief description that will
better describe the transaction.
TRN_DATE D 8 Transaction posting date -
mm/dd/yy.
PAT_DOC C 2 Patients normal doctor. Code
used to identify the doctor that
is normally responsable for this
patient. You can identify
another doctor that sees the
patient at time of transaction
posting.
RCL_LETTER C 2 Code used to identify the letter
Page 148
---------------------------------------------------------
FILE - RECALLS
---------------------------------------------------------
FIELD TYPE LEN DEC
form to use for this recall
request.
RCL_DATE D 8 Date recall is scheduled for -
mm/dd/yy.
RCL_COUNT C 1 Count of the number of recall
letters sent to patient for this
recall request. This count is
incremented by 1 for each letter
request. Max value is 9.
RCL_MSG_L1 C 40 Part one of two part message
that can be captured with each
patients recall request record.
This message is only for
internal use and is not printed
on recall letter to patient.
RCL_MSG_L2 C 40 Part two of two part message
that can be captured at time of
recall setup.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 158
Page 149
---------------------------------------------------------
FILE - CHGTABLE
---------------------------------------------------------
FIELD TYPE LEN DEC
CHG_TABLE C 2 Code to identify this charge
table of rates. You can setup
100 unique charge tables. The
table code of '00' is reserved
for the default 'standard'
charge table. Each table is
unique and is identified to the
patient at time of patient
setup. Table code can be
overriden at time of transaction
posting in order to post charges
to a patient from another table.
CHG_CODE C 8 Primary code used to identify
the charge, adjustment, or type
of payment. This code is
combined with the 'CHG_TABLE'
code in order to fully identify
the transaction.
CHG_DESC C 32 A brief description that will
better describe the transaction.
CHG_TYPE C 1 Code used to identify the type
of transaction being posted. 'C'
= charges, 'A' = adjustments,
'P' = payment
CHG_RATE N 8 2 Standard charge rate for this
transaction. (Note - this value
is only used for 'C' type
transactions.)
CHG_TAX C 1 Flag to identify if this charge
is to have the sales tax
calculated on it. This flag is
only valid for table 'CHG_TYPE'
codes of 'C'.
CHG_GLACCT C 8 General ledger account that this
transaction is to be posted
under in your general ledger.
CHG_RECALL C 1 Flag to identify if this
transaction is to be posted for
Page 150
---------------------------------------------------------
FILE - CHGTABLE
---------------------------------------------------------
FIELD TYPE LEN DEC
patient recall. ('Y' = setup for
recall, 'N' = do not setup for
recall)
CHG_HIST C 1 Flag to identify if this
transaction is to be recorded in
patients history file. ('Y' =
record in history, 'N' = do not
record in history)
RCL_LETTER C 2 Code used to identify the letter
form to use for this recall
request.
CHG_INS C 1 Flag in charge code table entry
to identify if this charge is
only to be considered as an
insurance posting to patients.
If 'N' then it is not considered
as an insurance posting. If 'Y'
then it is considered as an
insurance posting. (Note - this
field is not used in the
'SHAREWARE' version of MED#1.)
CHG_INV C 1 Inventory usage flag. ('Y' =
record inventory item use, 'N'
= no inventoryable item charged
to patient.) This field is not
currently used but is made
available for later
implementation of inventory
system.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 74
Page 151
---------------------------------------------------------
FILE - DOCTOR
---------------------------------------------------------
FIELD TYPE LEN DEC
DOCTOR C 2 Code used to identify a specific
doctor. You are required to
setup at least one doctor record
prior to any patient setup.
DOC_NAME C 32 Doctors name as it is to be
printed on all documents.
DOC_FNAME C 10 Doctors first name.
DOC_INIT C 1 Doctors middle initial.
DOC_TITLE C 10 Doctors medical titles.
DOC_ADD1 C 32 Doctor address line #1.
DOC_ADD2 C 32 Doctor address line #2.
DOC_CITY C 20 Doctor city name for address.
DOC_STATE C 16 Doctor state/country name for
address.
DOC_ZIP C 10 Doctor zip/postal code for
address.
DOC_TAXID C 10 Doctor's Medicare identification
number. This number will be
printed on the HCFA-1500
insurance form for all referring
doctors.
PHONE_1 C 12 Doctors 1st phone number.
REF_1 C 24 Reference description for phone
number #1.
PHONE_2 C 12 Doctors 2nd phone number.
REF_2 C 24 Reference description for phone
number #2.
PHONE_3 C 12 Doctors 3rd phone number.
REF_3 C 24 Reference description for phone
Page 152
---------------------------------------------------------
FILE - DOCTOR
---------------------------------------------------------
FIELD TYPE LEN DEC
number #3.
PHONE_4 C 12 Doctors 4th phone number.
REF_4 C 24 Reference description for phone
number #4.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 327
Page 153
---------------------------------------------------------
FILE - INSCO
---------------------------------------------------------
FIELD TYPE LEN DEC
INS_CODE C 8 Code used to identify this
insurance company.
INS_NAME C 32 Name of insurance company.
INS_ADD1 C 32 Address line #1 of insurance
company address.
INS_ADD2 C 32 Address line #2 for insurance
company address.
INS_CITY C 20 City name for address for
insurance company.
INS_STATE C 16 Insurance company state/country
name of address.
INS_ZIP C 10 Insurance company zip/postal
code for address.
INS_PHONE C 12 Insurance company phone number.
INS_PHEXT C 4 Insurance company phone
extension number to contact the
person that will help you with
claim processing.
INS_REP C 25 Name of insurance company
representative that the given
phone number will put you in
touch with.
INS_TITLE C 20 Insurance company title for
representative the given phone
number will put you in touch
with.
PAYOR C 5 NEIC assigned identification
number for this insurance
carrier.
PAYOR_SUB C 4 NEIC assigned identification
number for this insurance
carriers sub-office.
Page 154
---------------------------------------------------------
FILE - INSCO
---------------------------------------------------------
FIELD TYPE LEN DEC
PPO_TYPE C 1 If this insurance carrier
provides coverage under a: 'PPO'
enter 'P', 'HMO' enter 'H',
'Managed Care' enter 'M',
otherwise leave blank.
PPO_ID C 10 If this insurance carrier is a
PPO, HMO, or MANAGED CARE
provider enter the number for
their contract.
ECS_CODE C 7 If the claims for this insurance
carrier are to be process using
Electronic Claims Submission
sub-systems enter the ECS form
code here. Valid values are
'*ECS#1*', '*ECS#2*', and
'*ECS#3*'.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 246
Page 155
---------------------------------------------------------
FILE - LETTERS
---------------------------------------------------------
FIELD TYPE LEN DEC
LTR_CODE C 2 Code to identify this recall
letter format.
LTR_TITLE C 32 Descriptive title of letter that
will be displayed in the summary
display, and listing, of letters
on file.
LETTER M 10 Body of recall letter.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 52
Page 156
---------------------------------------------------------
FILE - TRAN
---------------------------------------------------------
FIELD TYPE LEN DEC
ACCT C 5 Primary identification code for
billing functions. Each account
can have from 1 to 999 patients.
PATIENT C 2 Code to identify this patient
within an account. You can have
up to 999 patients per account.
You must have at least one
patient per account.
PAT_DOC C 2 Patients normal doctor. Code
used to identify the doctor that
is normally responsable for this
patient. You can identify
another doctor that sees the
patient at time of transaction
posting.
CHG_TABLE C 2 Code to identify this charge
table of rates. You can setup
100 unique charge tables. The
table code of '00' is reserved
for the default 'standard'
charge table. Each table is
unique and is identified to the
patient at time of patient
setup. Table code can be
overriden at time of transaction
posting in order to post charges
to a patient from another table.
CHG_CODE C 8 Primary code used to identify
the charge, adjustment, or type
of payment. This code is
combined with the 'CHG_TABLE'
code in order to fully identify
the transaction.
TRN_POST D 8 General ledger posting flag. If
not blank this flag signifies
that this transaction has
already been posted to the
General Ledger.
TRN_DATE D 8 Transaction posting date -
Page 157
---------------------------------------------------------
FILE - TRAN
---------------------------------------------------------
FIELD TYPE LEN DEC
mm/dd/yy.
TRN_DAYSHT C 5 Transaction day sheet control
number (or invoice no.) - In
MED#1 this number is optional
but should be used if you use
prenumbered patient forms for
patient charges. This number can
be used for tracking adjustments
and receipts to actual charges.
TRN_DESC C 32 Transaction description - from
charge table but can be modified
at time of transaction posting.
TRN_TYPE C 1 Transaction type code - 'C' =
charge, 'A' = adjustment, 'P' =
payment.
TRN_PLSERV C 1 Transaction 'Place of Service'
code. This is one of the codes
found listed on the back of the
HCFA-1500 form that can be used
to identify the 'Place of
Service'. Only those codes found
on the back of the HCFA-1500
form are valid.
TRN_TYSERV C 1 Transaction 'Type of Service'
code. This is one of the codes
found listed on the back of the
HCFA-1500 insurance form that
can be used to identify the
'Type of Service' performed.
Only the codes found on the back
of the HCFA-1500 form are valid.
TRN_DXCODE C 8 Transaction diagnostic code.
This is in addition to the code
used to identify the
transaction.
TRN_DXCOD2 C 8 Second of four available
diagnosis codes that can be
associated with this
Page 158
---------------------------------------------------------
FILE - TRAN
---------------------------------------------------------
FIELD TYPE LEN DEC
transaction.
TRN_DXCOD3 C 8 Third of four diagnosis codes
that can be assigned to this
transaction.
TRN_DXCOD4 C 8 Fourth of four diagnosis codes
that can be assigned to this
transaction.
TRN_DOC C 2 Doctor seeing patient for this
transaction. This is the default
patient doctor but can be
changed at time of transaction
posting.
TRN_RATE N 8 2 The rate that was contained in
the charge table for this entry
at time of posting. This may be
different that actual charge
record due to operator override
ability at time of posting.
TRN_QTY N 3 0 Quantity of units that this
charge represents. ALL CURRENT
POSTINGS IN THIS SYSTEM WILL USE
THE VALUE 1.
TRN_AMT N 8 2 Transaction base amount prior to
any tax.
TRN_DISC N 8 2 Calculated discount amount of
charge that patient is allowed.
Discount percent is contained in
the account master for this
patient.
TRN_TAXYN C 1 Flag to identify if this entry
was taxable at time of posting
as determined by charge table
and account tax status. Because
operator can override calculated
tax amount this flag is required
to properly identify the entry
for G/L Journal posting as
Page 159
---------------------------------------------------------
FILE - TRAN
---------------------------------------------------------
FIELD TYPE LEN DEC
either taxable or non-taxable.
TRN_TAX N 6 2 Transaction tax charge.
Calculated at time of posting
but can be changed at time of
posting.
TRN_TOTAL N 8 2 Total transaction charge amount
that includes tax.
TRN_INSAMT N 8 2 That portion of total
transaction charge that is to be
subject to insurance coverage.
This value will be used in
future versions of MED#1 that
will provide for the reporting
of A/R covered/not covered by
insurance. (Note - this field is
not used in the 'SHAREWARE' ver
of MED#1.)
TRN_CKNO C 8 Transaction payment check number
- payments only.
TRN_GLACCT C 8 Transaction general ledger
posting code that this
transaction should be recorded
under in you G/L system.
TRN_GLPOST C 1 Flag to identify if this
transaction has been posted to
the General Ledger system.
TRN_PROVDR C 2 Patient code for member of this
account that provides insurance
coverage for this patients
charge entry.
TRN_INSBIL C 1 Flag used to identify this
transaction for processing for
insurance reporting and to
identifiy it as having been
posted for insurance.
TRN_ADJCD C 2 (currently not used)
Page 160
---------------------------------------------------------
FILE - TRAN
---------------------------------------------------------
FIELD TYPE LEN DEC
TRN_INS_CO C 8 If this transaction was
processed for insurance coverage
then this is the code for that
insurance company. This is
designed to assist in batching
all transactions for insurance
processing by company.
ECP_BATCH C 6 Electronic Claims Processing
batch control number. This field
will contain the claims
processing batch control number
assigned at time of initial
insurance claims extract and
processing. ECP will be
performed by a standalone
program to be provided by
MEDshare.
LUPDATE D 8 Date of last maintenance for
this record - mm/dd/yy.
TOTAL RECORD LENGTH.. 203
Page 161
---------------------------------------------------------
FILE - TAG_INS
---------------------------------------------------------
FIELD TYPE LEN DEC
ACCT C 5 Primary identification code for
billing functions. Each account
can have from 1 to 999 patients.
PATIENT C 2 Code to identify this patient
within an account. You can have
up to 999 patients per account.
You must have at least one
patient per account.
PS C 1 If this insurance claim is a
primary enter a 'P' otherwise
enter 'S'.
CLAIM C 1 Claim type to print: 'blank' =
plain paper, 1-9 for MEDICARE -
OTHER.
FORM C 7 Contains the form code for the
type of insurance form this
claim is filed on.
TOTAL RECORD LENGTH.. 16
Page 162
---------------------------------------------------------
FILE - TAG_RCAP
---------------------------------------------------------
FIELD TYPE LEN DEC
ACCT C 5 Primary identification code for
billing functions. Each account
can have from 1 to 999 patients.
PATIENT C 2 Code to identify this patient
within an account. You can have
up to 999 patients per account.
You must have at least one
patient per account.
TOTAL RECORD LENGTH.. 7
Page 163
---------------------------------------------------------
FILE - MEDGL
---------------------------------------------------------
FIELD TYPE LEN DEC
GL_CODE C 1 Code used to identify the type
of transaction this is within
the G/L Journal file. 1=charges
& adjustments, 2=sales tax, and
3=receipts.
GLACCT C 8 General Ledger account code as
contained in the charge table
record that posting was made
from.
ACCT C 5 Primary identification code for
billing functions. Each account
can have from 1 to 999 patients.
PATIENT C 2 Code to identify this patient
within an account. You can have
up to 999 patients per account.
You must have at least one
patient per account.
CHG_TABLE C 2 Code to identify this charge
table of rates. You can setup
100 unique charge tables. The
table code of '00' is reserved
for the default 'standard'
charge table. Each table is
unique and is identified to the
patient at time of patient
setup. Table code can be
overriden at time of transaction
posting in order to post charges
to a patient from another table.
CHG_CODE C 8 Primary code used to identify
the charge, adjustment, or type
of payment. This code is
combined with the 'CHG_TABLE'
code in order to fully identify
the transaction.
TRN_DOC C 2 Doctor seeing patient for this
transaction. This is the default
patient doctor but can be
changed at time of transaction
Page 164
---------------------------------------------------------
FILE - MEDGL
---------------------------------------------------------
FIELD TYPE LEN DEC
posting.
TRN_DATE D 8 Transaction posting date -
mm/dd/yy.
TRN_DESC C 32 Transaction description - from
charge table but can be modified
at time of transaction posting.
TRN_CKNO C 8 Transaction payment check number
- payments only.
GL_TAX N 7 2 Contains the tax amount for
taxable charges and adj.
GL_NTAXAMT N 11 2 Contains the non-taxable dollar
of charges and adj.
GL_TAXAMT N 11 2 Contains the taxable amount of
charges and adjustments.
TOTAL RECORD LENGTH.. 105
Page 165
---------------------------------------------------------
FILE - F_ERROR.LOG
---------------------------------------------------------
F_ERROR.LOG is a common 'ERROR' logging file used by ALL
programs developed by MEDshare, Inc. This file is only
used to capture 'ERROR' conditions that result in
abnormal program terminations due to an internal program
problem 'bug'. When a MEDshare, Inc. program terminates
in this manner the 'ERROR' condition is captured and a
text description of that 'ERROR' is written into this
file named F_ERROR.LOG. If the file F_ERROR.LOG does not
exist it is created. The information captured will
consist of: DATE, TIME, OPERATOR ID (if network), MODULE
NAME THAT FAILED, LINE NUMBER OF CODE LINE THAT FAILED,
and A BRIEF DESCRIPTION OF THE ERROR. With this
information it is possible to research the problem and
make a correction.
If you are having problems with any of your MEDshare,
Inc. programs, and you see entries made into this
F_ERROR.LOG file, copy this F_ERROR.LOG file to a
diskette and send it to:
MEDshare, Inc.
4100 West 15th, Suite #103
Plano, Texas 75093
Phone - Tech Support: 1 (214) 736-1067
If possible provide a brief description of your activity
for the time just prior to the 'ERROR' condition.
Include with this the name and phone number of the person
MEDshare, Inc. will need to contact if more information
is needed.
Page 166